https://gibs.com RSS feeds for Global Internet Business Solutions ~ GIBS 60 https://gibs.com/Support/Knowledge-Base/ID/2/SSRS_Date_Expressions#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=2 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=2&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/2/SSRS_Date_Expressions SSRS expressions to obtain the first and last days of any month, using the current month as a reference: First day of last month: =dateadd("m",-1,dateserial(year(Today),month(Today),1)) First day of this month: =dateadd("m",0,dateserial(year(Today),month(Today),1)) First day of next month: =dateadd("m",1,dateserial(year(Today),month(Today),1)) Last day of last month: =dateadd("m",0,dateserial(year(Today),month(Today),0)) Last day of this month: =dateadd("m",1,dateserial(year(Today),month(Today),0)) Last day of next month: =dateadd("m",2,dateserial(year(Today),month(Today),0)) First day of this year =DateSerial( year(today()), 1, 1) Last Day of this year =DateSerial( year(today()), 12, 31) Sat, 25 May 2024 12:41:00 GMT f1397696-738c-4295-afcd-943feb885714:2 https://gibs.com/Support/Knowledge-Base/ID/24/SSRS_Commonly_Used_DateTime_Functions#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=24 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=24&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/24/SSRS_Commonly_Used_DateTime_Functions The list below is a few simple functions which I've come across for generating various dates based on the current date/time (using the Now() function). Last day of the current year, =DateSerial(Year(Now()), 12, 31) Last day of previous month =DateAdd(""d"", -1, DateSerial(Year(Now()), Month(Now()), 1)) First date of previous month =DateAdd(""m"", -1, DateSerial(Year(Now()), Month(Now()), 1)) First day of last year =DateSerial(Year(Now())-1, 1, 1) Last day of last year =DateSerial(Year(Now())-1, 12, 31) Last day of this year =DateSerial(Year(Now()), 12, 31) First day of this year =DateSerial(Year(Now()), 1, 1) Sun, 19 Jan 2020 11:13:00 GMT f1397696-738c-4295-afcd-943feb885714:24